﻿<?xml version="1.0" encoding="utf-8"?><Articles><Article><ArticlesID>702</ArticlesID><Title>C&amp;#225;ch c&amp;#224;i đặt SQL Server 2008 Service Pack 1 (SP1)</Title><Body>&amp;lt;p&amp;gt;Trong phần trước m&amp;amp;igrave;nh đ&amp;amp;atilde; hướng dẫn c&amp;amp;aacute;c bạn c&amp;amp;agrave;i đặt SQL&amp;amp;nbsp;Server 2008 h&amp;amp;ocirc;m nay m&amp;amp;igrave;nh sẽ hướng dẫn tiếp c&amp;amp;aacute;ch c&amp;amp;agrave;i đặt bản n&amp;amp;acirc;ng cấp cho SQL&amp;amp;nbsp;Server 2008 đ&amp;amp;oacute; l&amp;amp;agrave; bản SQL&amp;amp;nbsp;Server 2008 SP1 (10.00.2531)&amp;lt;/p&amp;gt;
&amp;lt;p&amp;gt;Trước ti&amp;amp;ecirc;n bạn phải Download SQL&amp;amp;nbsp;Server 2008 SP1 &amp;lt;a href=&amp;quot;http://www.microsoft.com/downloads/details.aspx?FamilyID=66ab3dbb-bf3e-4f46-9559-ccc6a4f9dc19&amp;amp;amp;displaylang=en&amp;quot;&amp;gt;tại đ&amp;amp;acirc;y&amp;lt;/a&amp;gt;&amp;lt;br /&amp;gt;
&amp;lt;br /&amp;gt;
Sau khi Download xong bạn chạy file SQLServer2008SP1-KB968369-x86-ENU.exe &amp;lt;br /&amp;gt;
&amp;amp;nbsp;&amp;lt;/p&amp;gt;
&amp;lt;p&amp;gt;&amp;lt;img width=&amp;quot;404&amp;quot; height=&amp;quot;309&amp;quot; alt=&amp;quot;SQL Server 2008 SP1&amp;quot; src=&amp;quot;http://dev.meotom.net/Uploads/admin/2009/12/30/1764_image001.png&amp;quot; /&amp;gt;&amp;lt;br /&amp;gt;
&amp;amp;nbsp;&amp;lt;/p&amp;gt;
&amp;lt;p&amp;gt;Tiếp đ&amp;amp;oacute; Setup sẽ kiểm tra hệ thống của bạn trước khi tiến h&amp;amp;agrave;nh c&amp;amp;agrave;i đặt&amp;lt;br /&amp;gt;
&amp;amp;nbsp;&amp;lt;/p&amp;gt;
&amp;lt;p&amp;gt;&amp;lt;img width=&amp;quot;553&amp;quot; height=&amp;quot;414&amp;quot; alt=&amp;quot;SQL Server 2008 SP1&amp;quot; src=&amp;quot;http://dev.meotom.net/Uploads/admin/2009/12/30/1764_image002.png&amp;quot; /&amp;gt;&amp;lt;br /&amp;gt;
&amp;amp;nbsp;&amp;lt;/p&amp;gt;
&amp;lt;p&amp;gt;Bạn Click Next rồi chọn Accept License&amp;lt;br /&amp;gt;
&amp;lt;br /&amp;gt;
&amp;lt;br /&amp;gt;
&amp;lt;img width=&amp;quot;553&amp;quot; height=&amp;quot;413&amp;quot; alt=&amp;quot;&amp;quot; src=&amp;quot;http://dev.meotom.net/Uploads/admin/2009/12/30/1764_image003.png&amp;quot; /&amp;gt;&amp;lt;br /&amp;gt;
&amp;amp;nbsp;&amp;lt;/p&amp;gt;
&amp;lt;p&amp;gt;Tiếp đ&amp;amp;oacute; ở phần Select Features bạn chọn c&amp;amp;aacute;c phần để update l&amp;amp;ecirc;n SP1 ở đ&amp;amp;acirc;y c&amp;amp;oacute;&amp;lt;/p&amp;gt;
&amp;lt;p&amp;gt;Database Engine Services &amp;lt;br /&amp;gt;
&amp;amp;nbsp;&amp;amp;nbsp;&amp;amp;nbsp;&amp;amp;nbsp;&amp;amp;nbsp;SQL Server Replication&amp;lt;br /&amp;gt;
&amp;amp;nbsp;&amp;amp;nbsp;&amp;amp;nbsp;&amp;amp;nbsp;&amp;amp;nbsp;Full-Text Replication&amp;lt;br /&amp;gt;
Analysis Services &amp;lt;br /&amp;gt;
Reporting Services &amp;lt;br /&amp;gt;
Shared Features&amp;lt;br /&amp;gt;
&amp;amp;nbsp;&amp;amp;nbsp;&amp;amp;nbsp;&amp;amp;nbsp;&amp;amp;nbsp;Business Intelligence Development Studio &amp;lt;br /&amp;gt;
&amp;amp;nbsp;&amp;amp;nbsp;&amp;amp;nbsp;&amp;amp;nbsp;&amp;amp;nbsp;Client Tools Connectivity &amp;lt;br /&amp;gt;
&amp;amp;nbsp;&amp;amp;nbsp;&amp;amp;nbsp;&amp;amp;nbsp;&amp;amp;nbsp;Integration Services &amp;lt;br /&amp;gt;
&amp;amp;nbsp;&amp;amp;nbsp;&amp;amp;nbsp;&amp;amp;nbsp;&amp;amp;nbsp;Client Tools Backwards Compatibility &amp;lt;br /&amp;gt;
&amp;amp;nbsp;&amp;amp;nbsp;&amp;amp;nbsp;&amp;amp;nbsp;&amp;amp;nbsp;Client Tools SDK &amp;lt;br /&amp;gt;
&amp;amp;nbsp;&amp;amp;nbsp;&amp;amp;nbsp;&amp;amp;nbsp;&amp;amp;nbsp;SQL Server Books Online &amp;lt;br /&amp;gt;
&amp;amp;nbsp;&amp;amp;nbsp;&amp;amp;nbsp;&amp;amp;nbsp;&amp;amp;nbsp;Management Tools &amp;amp;ndash; Basic&amp;lt;br /&amp;gt;
&amp;amp;nbsp;&amp;amp;nbsp;&amp;amp;nbsp;&amp;amp;nbsp;&amp;amp;nbsp;&amp;amp;nbsp;&amp;amp;nbsp;&amp;amp;nbsp;&amp;amp;nbsp;Management Tools - Complete&amp;lt;br /&amp;gt;
&amp;amp;nbsp;&amp;lt;/p&amp;gt;
&amp;lt;p&amp;gt;&amp;lt;img width=&amp;quot;553&amp;quot; height=&amp;quot;416&amp;quot; alt=&amp;quot;SQL Server 2008 SP1&amp;quot; src=&amp;quot;http://dev.meotom.net/Uploads/admin/2009/12/30/1764_image004.png&amp;quot; /&amp;gt;&amp;lt;br /&amp;gt;
&amp;amp;nbsp;&amp;lt;/p&amp;gt;
&amp;lt;p&amp;gt;Sau đ&amp;amp;oacute; Click Next. Tiếp đ&amp;amp;oacute; Setup sẽ check lại c&amp;amp;aacute;c file đang sử dụng trong hệ thống.&amp;lt;br /&amp;gt;
&amp;amp;nbsp;&amp;lt;/p&amp;gt;
&amp;lt;p&amp;gt;&amp;lt;img width=&amp;quot;553&amp;quot; height=&amp;quot;412&amp;quot; alt=&amp;quot;&amp;quot; src=&amp;quot;http://dev.meotom.net/Uploads/admin/2009/12/30/1764_image005.png&amp;quot; /&amp;gt;&amp;lt;br /&amp;gt;
&amp;amp;nbsp;&amp;lt;/p&amp;gt;
&amp;lt;p&amp;gt;Sau khi Click v&amp;amp;agrave;o next Setup sẽ b&amp;amp;aacute;o Ready to Update v&amp;amp;agrave; bạn Click Update&amp;lt;br /&amp;gt;
&amp;amp;nbsp;&amp;lt;/p&amp;gt;
&amp;lt;p&amp;gt;&amp;lt;img width=&amp;quot;553&amp;quot; height=&amp;quot;414&amp;quot; alt=&amp;quot;SQL Server 2008 Sp1&amp;quot; src=&amp;quot;http://dev.meotom.net/Uploads/admin/2009/12/30/1764_image006.png&amp;quot; /&amp;gt;&amp;lt;/p&amp;gt;
&amp;lt;p&amp;gt;&amp;lt;br /&amp;gt;
Đợi qu&amp;amp;aacute; tr&amp;amp;igrave;nh update&amp;lt;br /&amp;gt;
&amp;amp;nbsp;&amp;lt;/p&amp;gt;
&amp;lt;p&amp;gt;&amp;lt;img width=&amp;quot;553&amp;quot; height=&amp;quot;415&amp;quot; alt=&amp;quot;&amp;quot; src=&amp;quot;http://dev.meotom.net/Uploads/admin/2009/12/30/1764_image007.png&amp;quot; /&amp;gt;&amp;lt;/p&amp;gt;
&amp;lt;p&amp;gt;&amp;lt;br /&amp;gt;
Sau khi Update xong&amp;lt;br /&amp;gt;
&amp;amp;nbsp;&amp;lt;/p&amp;gt;
&amp;lt;p&amp;gt;&amp;lt;img width=&amp;quot;553&amp;quot; height=&amp;quot;414&amp;quot; alt=&amp;quot;SQL Server 2008 SP1&amp;quot; src=&amp;quot;http://dev.meotom.net/Uploads/admin/2009/12/30/1764_image008.png&amp;quot; /&amp;gt;&amp;lt;/p&amp;gt;
&amp;lt;p&amp;gt;&amp;lt;br /&amp;gt;
v&amp;amp;agrave; bạn đ&amp;amp;atilde; ho&amp;amp;agrave;n tất c&amp;amp;agrave;i đặt SQL&amp;amp;nbsp;Server 2008 SP1&amp;lt;br /&amp;gt;
&amp;amp;nbsp;&amp;lt;/p&amp;gt;
&amp;lt;p&amp;gt;&amp;lt;img width=&amp;quot;553&amp;quot; height=&amp;quot;415&amp;quot; alt=&amp;quot;SQL Server 2008 SP1&amp;quot; src=&amp;quot;http://dev.meotom.net/Uploads/admin/2009/12/30/1764_image009.png&amp;quot; /&amp;gt;&amp;lt;/p&amp;gt;
&amp;lt;p&amp;gt;&amp;lt;br /&amp;gt;
Để kiểm tra phi&amp;amp;ecirc;n bản SQL&amp;amp;nbsp;Server đang sử dụng bạn Execute c&amp;amp;acirc;u lệnh n&amp;amp;agrave;y trong SQL Server Management Studio&amp;lt;/p&amp;gt;
&amp;lt;pre class=&amp;quot;brush: sql;&amp;quot; title=&amp;quot;code&amp;quot;&amp;gt;
SELECT
SERVERPROPERTY('Edition') AS 'Edition',
SERVERPROPERTY('ProductVersion') AS 'ProductVersion',
SERVERPROPERTY('ProductLevel') AS 'ProductLevel',
SERVERPROPERTY('ResourceLastUpdateDateTime') AS 'ResourceLastUpdateDateTime',
SERVERPROPERTY('ResourceVersion') AS 'ResourceVersion'
GO &amp;lt;/pre&amp;gt;
&amp;lt;p&amp;gt;&amp;lt;br /&amp;gt;
&amp;lt;img width=&amp;quot;553&amp;quot; height=&amp;quot;40&amp;quot; alt=&amp;quot;SQL Server 2008 SP1&amp;quot; src=&amp;quot;http://dev.meotom.net/Uploads/admin/2009/12/30/1764_image010.png&amp;quot; /&amp;gt;&amp;lt;/p&amp;gt;
&amp;lt;p&amp;gt;&amp;lt;br /&amp;gt;
Để xem th&amp;amp;ocirc;ng tin c&amp;amp;aacute;c lỗi được Fix trong SQL&amp;amp;nbsp;Server 2008 SP1 bạn tham khảo tại &amp;lt;a href=&amp;quot;http://support.microsoft.com/kb/968369&amp;quot;&amp;gt;link n&amp;amp;agrave;y&amp;lt;/a&amp;gt;&amp;lt;/p&amp;gt;
&amp;lt;p&amp;gt;Ngo&amp;amp;agrave;i ra v&amp;amp;agrave;o ng&amp;amp;agrave;y 22/9/2009 Microsoft đ&amp;amp;atilde; ra bản Cumulative update package 4 (CU4 10.0.2734) cho SQL Server 2008 Service Pack 1 bạn c&amp;amp;oacute; thể Request Download &amp;lt;a href=&amp;quot;http://support.microsoft.com/kb/973602/en-us&amp;quot;&amp;gt;tại đ&amp;amp;acirc;y&amp;lt;/a&amp;gt;.&amp;lt;/p&amp;gt;
&amp;lt;p&amp;gt;Nếu bạn đang d&amp;amp;ugrave;ng bản SQL&amp;amp;nbsp;Server 2008 RTM&amp;amp;nbsp;(10.0.1600)&amp;amp;nbsp;v&amp;amp;agrave; c&amp;amp;agrave;i đặt SQL&amp;amp;nbsp;Server 2008 SP1 bị lỗi th&amp;amp;igrave; bạn c&amp;amp;oacute; thể download bản pack RTM&amp;amp;nbsp;CU1 &amp;lt;a href=&amp;quot;http://support.microsoft.com/kb/956717/&amp;quot;&amp;gt;tại đ&amp;amp;acirc;y&amp;lt;/a&amp;gt; rồi tiến h&amp;amp;agrave;nh c&amp;amp;agrave;i đặt b&amp;amp;igrave;nh thường.&amp;lt;/p&amp;gt;</Body><CommentEnabled>True</CommentEnabled><ViewCount>0</ViewCount><ReleaseDate>12/30/2009 10:45:04 PM</ReleaseDate><TotalComment>0</TotalComment><IsMedia>False</IsMedia><IsPicture>True</IsPicture><IsVote>True</IsVote><ArticlePassword /><PostVisible>0</PostVisible><ArticlePath>/2009/12/30/Cach-cai-dat-SQL-Server-2008-Service-Pack-1-SP1-2BE</ArticlePath><Approved>True</Approved><ImagePath /><CategoryId>23</CategoryId><ArrayCatID>23|0</ArrayCatID></Article></Articles>